
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[EBAS_SP_HENT_GYLDIG_LICENSER]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[EBAS_SP_HENT_GYLDIG_LICENSER]
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS OFF 
GO

CREATE PROCEDURE [DBO].[EBAS_SP_HENT_GYLDIG_LICENSER] 
	@type varchar(255) = '%'
WITH ENCRYPTION	
AS
	SET NOCOUNT ON	
	
	SELECT LICENS_TIL, LICENS_NUMMER, LICENS_TYPE, SLUT_DATO 
	FROM EBAS_LICENS
	WHERE SLUT_DATO > GetDate()
	AND LICENS_TYPE = @type
GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO
